SQLfast scripts of Case studies "Interactive SQL interpreters"
-------------------------------------------------------------

The directory comprises:
   1. a sets of SQLfast files
   2. directory "SQL-Tutor".

1. Set of SQLfast files
   This set of files implements the collection of SQL interpreters developed in the case study.
   - SQL-Interpreter-MAIN:
          The main script. To execute to experiment with the series of SQL interpreters.
   - _SQL-Interpreter-V00.sql and _SQL-Interpreter-V01.sql:
          The "smallest interactive SQL interpreters in the world".
   - _SQL-Interpreter-V1.sql to _SQL-Interpreter-V6.sql: 
          The series of "realistic" interactive SQL interpreters of the case study.
   - __SQL-ErrorProcessing.sql:
          The error processing procedure. Just a prototype. Must be completed.
   - SQL-Interpreter.tuto:
          Tutorial used by "SQL-Interpreter-V7". Includes just the title. Must be completed.

2. Directory "SQL-Tutor"
   A fully functional prototype of the "SQL tutor" application with some first exercise sets.
   - SQL-Tutor-STUDENT.sql:
          The main script of the application. Execute it to start the "SQL tutor".
          Calls the secondary scripts described below.

   - SQL tutor secondary scripts:
     - _Create-SQL-Tutor.sql:
           creates the "SQLtutor.db" database
     - _Get-parameters.sql:
           getting the set of exercises to solve + other parameters
     - _Select-an-exercise.sql:
           lets the student choose the next exercise
     - _Execute-reference-query.sql:
           executes the reference query
     - _Execute-student-query.sql:
           executes the student's query
     - _Submit-an-answer.sql:
           lets the student enter his answer
     - _Compute-metrics.sql:
           computes metrics N1, N2, N12, N21
     - _Create-diagnostic-EN.sql:
           creates the diagnostic message from the metrics
     - _Display-exercises-instructions.sql:
           creates and displays the exercuse set through temporary file "SQLtutor.tuto"
     - _Display-result-and-correct.sql:
           displays the diagnostic message and lets the student modify his answer
     - _Display-result-and-correct-v2.sql

   - A first portfolio of SQL exercises:
     - SQL-Exercises-01-EN.sql: "basic", "sub-query" and "join" exercises (English)
     - SQL-Exercises-01-FR.sql: "basic", "sub-query" and "join" exercises (French)
     - SQL-Exercises-02-EN.sql: some "group by" exercises (English)
     - SQL-Exercises-02-FR.sql: some "group by" exercises (French)
     - <to be continued ...>

